Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderTypeCode (FK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type | TY_TND | Code | varchar(20) | BrandedTenderMedia(CO_BRN_TND_MD) |
TenderTypeCode (FK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
TenderTypeCode (FK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type | TY_TND | Code | varchar(20) | TenderAccountApprovalReference(CO_RFC_TND_APVL) |
TenderSubTypeCode | A mnemonic code denoting the sub-type of this particular TenderLineItem | TY_LTM_TND | Code4 | char(4) | |
ReasonCode (FK) | A unique retailer defined reason code for including this TenderLineItem in the transaction. | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
IsChangeFlag | If true, denotes that the Tender is returned by the retailer to the Customer. | FL_IS_CHNG | Flag | integer | |
AccountNumber (FK) | The CUSTOMER's account number against which previous tender authorization is held. | ID_ACNT_NMB | Identity | integer | TenderAccountApprovalReference(CO_RFC_TND_APVL) |
TenderAccountNumber | The account number of the customer tendering the TENDER. This account number is retained as a means of an authorization history against which future payments can be referenced. | ID_ACNT_TND | Identity | integer | |
CoPayFlag | A flag denoting that this TenderLineItem is a Customer Co-Payment against a drugstore purchase. | FL_CO_PAY | Flag | integer | |
ForeignCurrencyAmount | The monetary value (in the currency submitted by the Customer) of the tender submitted by the Customer. | MO_FRG_CY | MoneyShortRetail | decimal(7,2) | |
ForeignCurrencyID | A unique identifier that describes the foreign Currency. | ID_CNY_FRG | Identity | integer | |
ExchangeRate | The exchange rate used to convert the tendered amount into the default currency of the retail enterprise. | MO_RTE_EXC | MoneyShortCost | decimal(16,5) | |
TenderAmount | The monetary value (in the default currency of the retail enterprise) of the tender submitted by the Customer. | MO_ITM_LN_TND | Money | decimal(16,5) | |
AmountAppliedToTransaction | The monetary amount being applied to the TransactionTotal. | MO_TRN_AMT | MoneyShortRetail | decimal(7,2) | |
TipAmount | The monetary amount (in the default currency of the retail enterprise) being collected as Tip for serving staff. | MO_TIP | MoneyShortRetail | decimal(7,2) | |
TipForeignCurrencyAmount | The monetary amount (in the tendered currency) being collected as Tip for serving staff. | MO_TIP_FRG_CY | MoneyShortRetail | decimal(7,2) | |
CashbackAmount | The monetary value (in the default currency of the retail enterprise) of the tender returned to the Customer. | MO_CSH_BCK | MoneyShortRetail | decimal(7,2) | |
CashbackForeignCurrencyAmount | The monetary value (in the currency being returned) of the tender returned to the Customer. | MO_CSH_BCK_FRG_CY | MoneyShortRetail | decimal(7,2) | |
AddressVerificationCode | A code denoting how the customer's address was verified. | TY_VR_ADS | Code2 | char(2) | |
TenderMediaBrandID (FK) | Token identifier for a tender media brand. | ID_TND_MD_BRN | Identity | integer | BrandedTenderMedia(CO_BRN_TND_MD) |